﻿-- =============================================
-- Script Template
-- =============================================

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/****Create Default Records ****/
PRINT 'INSERTING DEFAULT DATA .... [Sys_RoleActivity]'
GO

-- ==============================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
-- Data for System Super Admin
-- ==============================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 1, N'SYSSPRADM', N'System Super Admin', N'VIEW_SYSADMINDASHBOARD', N'View System Administration Dashboard', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 2, N'SYSSPRADM', N'System Super Admin', N'CREATE_ACTIVITYMASTER', N'Create Activity Master Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 3, N'SYSSPRADM', N'System Super Admin', N'READ_ACTIVITYMASTER', N'Read Activity Master Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 4, N'SYSSPRADM', N'System Super Admin', N'UPDATE_ACTIVITYMASTER', N'Update Activity Master Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 5, N'SYSSPRADM', N'System Super Admin', N'DELETE_ACTIVITYMASTER', N'Delete Activity Master Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 6, N'SYSSPRADM', N'System Super Admin', N'CREATE_ROLEMASTER', N'Create Role Master Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 7, N'SYSSPRADM', N'System Super Admin', N'READ_ROLEMASTER', N'Read Role Master Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 8, N'SYSSPRADM', N'System Super Admin', N'UPDATE_ROLEMASTER', N'Update Role Master Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 9, N'SYSSPRADM', N'System Super Admin', N'DELETE_ROLEMASTER', N'Delete Role Master Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 10, N'SYSSPRADM', N'System Super Admin', N'CREATE_ROLEACTIVITY', N'Create RoleActivity Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 11, N'SYSSPRADM', N'System Super Admin', N'READ_ROLEACTIVITY', N'Read RoleActivity Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 12, N'SYSSPRADM', N'System Super Admin', N'UPDATE_ROLEACTIVITY', N'Update RoleActivity Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 13, N'SYSSPRADM', N'System Super Admin', N'DELETE_ROLEACTIVITY', N'Delete RoleActivity Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 14, N'SYSSPRADM', N'System Super Admin', N'READ_SESSIONLOG', N'Read SessionLog Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 15, N'SYSSPRADM', N'System Super Admin', N'DELETE_SESSIONLOG', N'Delete SessionLog Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 16, N'SYSSPRADM', N'System Super Admin', N'READ_ERRORLOG', N'Read ErrorLog Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 17, N'SYSSPRADM', N'System Super Admin', N'DELETE_ERRORLOG', N'Delete ErrorLog Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 18, N'SYSSPRADM', N'System Super Admin', N'READ_SIGNUP', N'Read SignUp Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 19, N'SYSSPRADM', N'System Super Admin', N'UPDATE_SIGNUP', N'Update SignUp Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 20, N'SYSSPRADM', N'System Super Admin', N'DELETE_SIGNUP', N'Delete SignUp Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 21, N'SYSSPRADM', N'System Super Admin', N'CREATE_GENERALFEEDBACK', N'Create General Feedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 22, N'SYSSPRADM', N'System Super Admin', N'READ_GENERALFEEDBACK', N'Read General Feedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 25, N'SYSSPRADM', N'System Super Admin', N'DELETE_GENERALFEEDBACK', N'Delete General Feedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 28, N'SYSSPRADM', N'System Super Admin', N'READ_CONTACTUS', N'Read ContactUs Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 31, N'SYSSPRADM', N'System Super Admin', N'DELETE_CONTACTUS', N'Delete ContactUs Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 32, N'SYSSPRADM', N'System Super Admin', N'READ_SUBSCRIPTION', N'Read Subscription Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 33, N'SYSSPRADM', N'System Super Admin', N'CREATE_PROJECTMEMBER', N'Create ProjectMember Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 34, N'SYSSPRADM', N'System Super Admin', N'READ_PROJECTMEMBER', N'Read ProjectMember Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 36, N'SYSSPRADM', N'System Super Admin', N'UPDATE_PROJECTMEMBER', N'Update ProjectMember Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 38, N'SYSSPRADM', N'System Super Admin', N'DELETE_PROJECTMEMBER', N'Delete ProjectMember Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 39, N'SYSSPRADM', N'System Super Admin', N'CREATE_PROJECTCONTENT', N'Create ProjectContent Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 40, N'SYSSPRADM', N'System Super Admin', N'READ_PROJECTCONTENT', N'Read ProjectContent Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 41, N'SYSSPRADM', N'System Super Admin', N'UPDATE_PROJECTCONTENT', N'Update ProjectContent Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 42, N'SYSSPRADM', N'System Super Admin', N'DELETE_PROJECTCONTENT', N'Delete ProjectContent Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 44, N'SYSSPRADM', N'System Super Admin', N'READ_PROJECTFEEDBACK', N'Read ProjectFeedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 48, N'SYSSPRADM', N'System Super Admin', N'DELETE_PROJECTFEEDBACK', N'Delete ProjectFeedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 50, N'SYSSPRADM', N'System Super Admin', N'READ_BLOGCONTENT', N'Read BlogContent Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 54, N'SYSSPRADM', N'System Super Admin', N'DELETE_BLOGCONTENT', N'Delete BlogContent Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 56, N'SYSSPRADM', N'System Super Admin', N'READ_BLOGFEEDBACK', N'Read BlogFeedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 60, N'SYSSPRADM', N'System Super Admin', N'DELETE_BLOGFEEDBACK', N'Delete BlogFeedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 69, N'SYSSPRADM', N'System Super Admin', N'CREATE_USERROLEALLOT', N'Create User Role Allocation Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 70, N'SYSSPRADM', N'System Super Admin', N'READ_USERROLEALLOT', N'Read User Role Allocation Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 71, N'SYSSPRADM', N'System Super Admin', N'UPDATE_USERROLEALLOT', N'Update User Role Allocation Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 72, N'SYSSPRADM', N'System Super Admin', N'DELETE_USERROLEALLOT', N'Delete User Role Allocation Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 73, N'SYSSPRADM', N'System Super Admin', N'CREATE_CONTTYPEMASTER', N'Create Content Type Master Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 74, N'SYSSPRADM', N'System Super Admin', N'READ_CONTTYPEMASTER', N'Read Content Type Master Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 75, N'SYSSPRADM', N'System Super Admin', N'UPDATE_CONTTYPEMASTER', N'Update Content Type Master Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 76, N'SYSSPRADM', N'System Super Admin', N'DELETE_CONTTYPEMASTER', N'Delete Content Type Master Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

-- ==============================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
-- Data for System Admin
-- ==============================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 1, N'SYSADMIN', N'System Admin', N'VIEW_SYSADMINDASHBOARD', N'View System Administration Dashboard', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 3, N'SYSADMIN', N'System Admin', N'READ_ACTIVITYMASTER', N'Read Activity Master Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 7, N'SYSADMIN', N'System Admin', N'READ_ROLEMASTER', N'Read Role Master Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 11, N'SYSADMIN', N'System Admin', N'READ_ROLEACTIVITY', N'Read RoleActivity Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 14, N'SYSADMIN', N'System Admin', N'READ_SESSIONLOG', N'Read SessionLog Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 15, N'SYSADMIN', N'System Admin', N'DELETE_SESSIONLOG', N'Delete SessionLog Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 16, N'SYSADMIN', N'System Admin', N'READ_ERRORLOG', N'Read ErrorLog Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 17, N'SYSADMIN', N'System Admin', N'DELETE_ERRORLOG', N'Delete ErrorLog Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 18, N'SYSADMIN', N'System Admin', N'READ_SIGNUP', N'Read SignUp Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 19, N'SYSADMIN', N'System Admin', N'UPDATE_SIGNUP', N'Update SignUp Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 20, N'SYSADMIN', N'System Admin', N'DELETE_SIGNUP', N'Delete SignUp Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 22, N'SYSADMIN', N'System Admin', N'READ_GENERALFEEDBACK', N'Read General Feedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 25, N'SYSADMIN', N'System Admin', N'DELETE_GENERALFEEDBACK', N'Delete General Feedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 28, N'SYSADMIN', N'System Admin', N'READ_CONTACTUS', N'Read ContactUs Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 31, N'SYSADMIN', N'System Admin', N'DELETE_CONTACTUS', N'Delete ContactUs Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 32, N'SYSADMIN', N'System Admin', N'READ_SUBSCRIPTION', N'Read Subscription Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 33, N'SYSADMIN', N'System Admin', N'CREATE_PROJECTMEMBER', N'Create ProjectMember Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 34, N'SYSADMIN', N'System Admin', N'READ_PROJECTMEMBER', N'Read ProjectMember Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 36, N'SYSADMIN', N'System Admin', N'UPDATE_PROJECTMEMBER', N'Update ProjectMember Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 38, N'SYSADMIN', N'System Admin', N'DELETE_PROJECTMEMBER', N'Delete ProjectMember Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 39, N'SYSADMIN', N'System Admin', N'CREATE_PROJECTCONTENT', N'Create ProjectContent Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 40, N'SYSADMIN', N'System Admin', N'READ_PROJECTCONTENT', N'Read ProjectContent Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 41, N'SYSADMIN', N'System Admin', N'UPDATE_PROJECTCONTENT', N'Update ProjectContent Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 42, N'SYSADMIN', N'System Admin', N'DELETE_PROJECTCONTENT', N'Delete ProjectContent Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 44, N'SYSADMIN', N'System Admin', N'READ_PROJECTFEEDBACK', N'Read ProjectFeedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 48, N'SYSADMIN', N'System Admin', N'DELETE_PROJECTFEEDBACK', N'Delete ProjectFeedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 50, N'SYSADMIN', N'System Admin', N'READ_BLOGCONTENT', N'Read BlogContent Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 54, N'SYSADMIN', N'System Admin', N'DELETE_BLOGCONTENT', N'Delete BlogContent Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 56, N'SYSADMIN', N'System Admin', N'READ_BLOGFEEDBACK', N'Read BlogFeedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 60, N'SYSADMIN', N'System Admin', N'DELETE_BLOGFEEDBACK', N'Delete BlogFeedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 64, N'SYSADMIN', N'System Admin', N'READ_MYPROFILE', N'Read MyProfile Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 68, N'SYSADMIN', N'System Admin', N'DELETE_MYPROFILE', N'Delete MyProfile Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 70, N'SYSADMIN', N'System Admin', N'READ_USERROLEALLOT', N'Read User Role Allocation Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 74, N'SYSADMIN', N'System Admin', N'READ_CONTTYPEMASTER', N'Read Content Type Master Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

-- ==============================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
-- Data for System Operator
-- ==============================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 1, N'SYSOPRAT', N'System Operator', N'VIEW_SYSADMINDASHBOARD', N'View System Administration Dashboard', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 3, N'SYSOPRAT', N'System Operator', N'READ_ACTIVITYMASTER', N'Read Activity Master Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 7, N'SYSOPRAT', N'System Operator', N'READ_ROLEMASTER', N'Read Role Master Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 11, N'SYSOPRAT', N'System Operator', N'READ_ROLEACTIVITY', N'Read RoleActivity Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 14, N'SYSOPRAT', N'System Operator', N'READ_SESSIONLOG', N'Read SessionLog Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 15, N'SYSOPRAT', N'System Operator', N'DELETE_SESSIONLOG', N'Delete SessionLog Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 16, N'SYSOPRAT', N'System Operator', N'READ_ERRORLOG', N'Read ErrorLog Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 17, N'SYSOPRAT', N'System Operator', N'DELETE_ERRORLOG', N'Delete ErrorLog Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 18, N'SYSOPRAT', N'System Operator', N'READ_SIGNUP', N'Read SignUp Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 22, N'SYSOPRAT', N'System Operator', N'READ_GENERALFEEDBACK', N'Read General Feedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 28, N'SYSOPRAT', N'System Operator', N'READ_CONTACTUS', N'Read ContactUs Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 32, N'SYSOPRAT', N'System Operator', N'READ_SUBSCRIPTION', N'Read Subscription Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 33, N'SYSOPRAT', N'System Operator', N'CREATE_PROJECTMEMBER', N'Create ProjectMember Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 34, N'SYSOPRAT', N'System Operator', N'READ_PROJECTMEMBER', N'Read ProjectMember Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 36, N'SYSOPRAT', N'System Operator', N'UPDATE_PROJECTMEMBER', N'Update ProjectMember Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 38, N'SYSOPRAT', N'System Operator', N'DELETE_PROJECTMEMBER', N'Delete ProjectMember Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 48, N'SYSOPRAT', N'System Operator', N'DELETE_PROJECTFEEDBACK', N'Delete ProjectFeedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 60, N'SYSOPRAT', N'System Operator', N'DELETE_BLOGFEEDBACK', N'Delete BlogFeedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 74, N'SYSOPRAT', N'System Operator', N'READ_CONTTYPEMASTER', N'Read Content Type Master Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

-- ==============================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
-- Data for Registered User
-- ==============================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 21, N'SYSREGUSR', N'System Registered User', N'CREATE_GENERALFEEDBACK', N'Create General Feedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 22, N'SYSREGUSR', N'System Registered User', N'READ_GENERALFEEDBACK', N'Read General Feedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 24, N'SYSREGUSR', N'System Registered User', N'REMOVE_GENERALFEEDBACK', N'Remove General Feedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 26, N'SYSREGUSR', N'System Registered User', N'CREATE_CONTACTUS', N'Create ContactUs Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 27, N'SYSREGUSR', N'System Registered User', N'SEE_CONTACTUS', N'See ContactUs Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 29, N'SYSREGUSR', N'System Registered User', N'EDIT_CONTACTUS', N'Edit ContactUs Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 30, N'SYSREGUSR', N'System Registered User', N'REMOVE_CONTACTUS', N'Remove ContactUs Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 33, N'SYSREGUSR', N'System Registered User', N'CREATE_PROJECTMEMBER', N'Create ProjectMember Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 34, N'SYSREGUSR', N'System Registered User', N'READ_PROJECTMEMBER', N'Read ProjectMember Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 35, N'SYSREGUSR', N'System Registered User', N'EDIT_PROJECTMEMBER', N'Edit ProjectMember Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 37, N'SYSREGUSR', N'System Registered User', N'REMOVE_PROJECTMEMBER', N'Remove ProjectMember Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 40, N'SYSREGUSR', N'System Registered User', N'READ_PROJECTCONTENT', N'Read ProjectContent Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 43, N'SYSREGUSR', N'System Registered User', N'CREATE_PROJECTFEEDBACK', N'Create ProjectFeedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 44, N'SYSREGUSR', N'System Registered User', N'READ_PROJECTFEEDBACK', N'Read ProjectFeedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 45, N'SYSREGUSR', N'System Registered User', N'EDIT_PROJECTFEEDBACK', N'Edit ProjectFeedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 47, N'SYSREGUSR', N'System Registered User', N'REMOVE_PROJECTFEEDBACK', N'Remove ProjectFeedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 49, N'SYSREGUSR', N'System Registered User', N'CREATE_BLOGCONTENT', N'Create BlogContent Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 50, N'SYSREGUSR', N'System Registered User', N'READ_BLOGCONTENT', N'Read BlogContent Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 51, N'SYSREGUSR', N'System Registered User', N'EDIT_BLOGCONTENT', N'Edit BlogContent Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 53, N'SYSREGUSR', N'System Registered User', N'REMOVE_BLOGCONTENT', N'Remove BlogContent Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 55, N'SYSREGUSR', N'System Registered User', N'CREATE_BLOGFEEDBACK', N'Create BlogFeedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 56, N'SYSREGUSR', N'System Registered User', N'READ_BLOGFEEDBACK', N'Read BlogFeedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 57, N'SYSREGUSR', N'System Registered User', N'EDIT_BLOGFEEDBACK', N'Edit BlogFeedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 59, N'SYSREGUSR', N'System Registered User', N'REMOVE_BLOGFEEDBACK', N'Remove BlogFeedback Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 61, N'SYSREGUSR', N'System Registered User', N'VIEW_MYDASHBOARD', N'View My Dashboard', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 62, N'SYSREGUSR', N'System Registered User', N'CREATE_MYPROFILE', N'Create MyProfile Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 63, N'SYSREGUSR', N'System Registered User', N'SEE_MYPROFILE', N'See MyProfile Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 65, N'SYSREGUSR', N'System Registered User', N'EDIT_MYPROFILE', N'Edit MyProfile Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RoleKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, 67, N'SYSREGUSR', N'System Registered User', N'REMOVE_MYPROFILE', N'Remove MyProfile Data', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
